import java.sql.Connection;

import com.dhtmlx.connector.*;

public class grid_05a_select_filter_connector extends ConnectorServlet {

	@Override
	protected void configure() {
		Connection conn= ( new DataBaseConnection()).getConnection();

		GridConnector c = new GridConnector(conn);
		c.dynamic_loading(100);

		BaseConnector filter1 = new OptionsConnector(conn);
		filter1.render_sql("SELECT  DISTINCT SUBSTR(item_nm,1,2) as value from grid50","item_id","item_nm(value)");
		c.set_options("item_nm",filter1);

		c.render_table("grid50000", "item_id", "item_nm,item_cd");

	}

}
